package sg.edu.nus.iss.leavesystem.dataaccess.mysql;

public class DBConstants {
	public static final String driverName = "com.mysql.jdbc.Driver";
	public static final String dbUrl = "jdbc:mysql://localhost/mydb";
	public static final String dbUsername = "root";
	public static final String dbPassword = "";

	// Table names
	public static final String usersTableName = "user";
	public static final String employeesTableName = "employee";
	public static final String empLeaveDayTableName = "employee_leaveday";
	public static final String leaveTableName = "leave";
	public static final String leaveTypeTableName = "leave_type";
	public static final String roleTableName = "role";
	public static final String roleLeaveTypeTableName = "role_leavetype";
	
	//Users table field names
    public static final String u_userId = "user_id";
    public static final String u_userName = "user_name";
    public static final String u_userPassword = "user_password";
    public static final String u_empId = "emp_id";
    
    //Role_LeaveType field names
    public static final String rlt_roleId = "role_id";
    public static final String rlt_leaveTypeId = "leavetype_id";
    public static final String rlt_days = "days";
    
    //Role field names
    public static final String r_roleId = "role_id";
    public static final String r_roleName = "role_name";
    public static final String r_roleDescription = "role_description";
    
    //Leave_Type field names
    public static final String lt_leaveTypeId = "leavetype_id";
    public static final String lt_leaveTypeName = "leavetype_name";
}
